﻿CREATE TABLE [dbo].[TempStores]
(
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CountryId] [smallint] NOT NULL,
	[Code] [varchar](50) NOT NULL,
	[Name] [varchar](200) NOT NULL,
	[Region] [varchar] (100) NULL,
	[Subregion] [varchar](100) NULL,
	[City] [varchar] (100) NULL,
	[State] [varchar] (100) NULL,
	[SEL] [varchar] (100) NULL,
	[ShoppingOccasion] [varchar] (100) NULL,
	[Size] [varchar] (100) NULL,
	[Address] [varchar](400) NULL,
	[Phone] [varchar](50) NULL,
	[Fax] [varchar](50) NULL,
	[Format][varchar](100) NULL,
	[PBL] [varchar](100) NULL,
	[Mail] [varchar](100) NULL,
	[Contact] [varchar](100) NULL,
	[SiteLocation] [varchar](100) NULL,
	[ShopType] [varchar](100) NULL,
	[Layout] [varchar](100) NULL,
	[OpeningHours] [varchar](100) NULL,
	[Attribute1] [varchar](100) NULL,
	[Attribute2] [varchar](100) NULL,
	
	[SELCustomers] [varchar](100) NULL,
	[SELLocation] [varchar](100) NULL
)
